CREATE TABLE [dbo].[TDDIRE_PROV]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_PROV] [dbo].[TD_VC_020] NOT NULL,
[TI_DIRE] [dbo].[TD_VC_003] NOT NULL,
[DE_DIRE] [dbo].[TD_VC_100] NULL,
[DE_REFE] [dbo].[TD_VC_100] NULL,
[CO_UBIC_GEOG] [dbo].[TD_VC_006] NULL,
[DE_CIUD] [dbo].[TD_VC_020] NULL,
[DE_DPTO] [dbo].[TD_VC_020] NULL,
[CO_PAIS] [dbo].[TD_VC_003] NULL,
[NU_TLF1] [dbo].[TD_VC_020] NULL,
[NU_TLF2] [dbo].[TD_VC_020] NULL,
[NU_FAXS] [dbo].[TD_VC_020] NULL,
[NO_CONC] [dbo].[TD_VC_050] NULL,
[DE_DIRE_MAIL] [dbo].[TD_VC_050] NULL,
[CO_POST] [dbo].[TD_VC_004] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TDDIRE_PR__CO_US__03DB89B3] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TDDIRE_PR__FE_US__04CFADEC] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TDDIRE_PR__CO_US__05C3D225] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TDDIRE_PR__FE_US__06B7F65E] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDDIRE_PROV] ADD CONSTRAINT [PK__TDDIRE_P__8D7240AE493AB229] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_PROV], [TI_DIRE]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TDDIRE_PROV] ADD CONSTRAINT [FK__TDDIRE_PROV__464936E5] FOREIGN KEY ([CO_EMPR], [CO_PROV]) REFERENCES [dbo].[TMPROV_TESO] ([CO_EMPR], [CO_PROV])
GO
